package com.kayt.cyberBar.cuser.business.dao;

import java.sql.SQLException;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

import com.kayt.cyberBar.common.PageData;
import com.kayt.cyberBar.cuser.business.entity.po.BUserAssessDetail;

public interface IUserAssessDetailDao {
	Integer save(BUserAssessDetail entity) throws SQLException;

	Integer update(BUserAssessDetail entity) throws SQLException;

	Integer delete(Integer id);

	BUserAssessDetail findById(Integer id);

	public PageData<BUserAssessDetail> findByPage(int pageNum, int pageSize, String hql, Object[] params,
			LinkedHashMap<String, String> orderMap) throws SQLException;

	PageData<Map<String, Object>> getByStoreCode(String storeCode, String assessDate, Integer pageNum, Integer pageSize,
			String sortNum, String sortOrder , String userCode) throws SQLException;

	PageData<Map<String, Object>> getByUserCode(String userCode, String assessDate, Integer pageNum, Integer pageSize)
			throws SQLException;

	List<BUserAssessDetail> getByUserAndMonth(String userCode, String assessDate) throws SQLException;
}
